USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_SkillSetInsert'))
	EXEC('CREATE PROC dbo.training_api_SkillSetInsert AS')
GO

ALTER PROC dbo.training_api_SkillSetInsert
	@Title		nvarchar(200),
	@SkillSetID	int	output
AS
	INSERT INTO SkillSet(
		Title)
	VALUES(
		@Title)
	SELECT @SkillSetID = SCOPE_IDENTITY()
